Released on: May 23, 2008, 4:29 pm

Press Release Author: Alba Spectrum

Industry: Computers

Press Release Summary: Microsoft Dynamics GP has variety of modification tools:
Dexterity, eConnect, SDK for Visual Studio Developer, then SQL stored procedures
should be considers as advanced scripting option.

Press Release Body: Microsoft Dynamics GP has variety of modification tools:
Dexterity, eConnect, SDK for Visual Studio Developer, then SQL stored procedures
should be considers as advanced scripting option. In this small article we would
like to give you introduction level highlights, assuming that you are in the MRP
selection phase and your implementation requires customization, integration,
programming, data conversion, cross-platform reporting

1. Great Plains Dexterity. This tool requires several years of extensive
programming experience, and at the same time it allows you as software programmer to
customize the most advanced scenarios of GP business logic. Dexterity is written in
C programming language as EDI shell, in turn it has its own programming language
sanscript. You typically rescue to Dex, when other tolls or SDK don't do the job

2. eConnect. It is in essence SDK with C# and VB sample codes, plus it has layers
of technologies ending up at the database side with SQL encrypted stored procedures.
eConnect was introduced as the tool for ecommerce web developer to integrate GP as
back office accounting and Sales Order Processing system

3. SQL Scripting. If you need relatively simple data integration without deploying
expensive tools, consider SQL Insert statement based scripts and stored procedures.
Alternatively you can incorporate these constructions into DTS or Data
Transformation Services package. Please, be sure that you are familiar with GP
tables structure and data flow, please install GP SDK from CD #2

4. Cross Platform Integrations. If your legacy system database is not Microsoft SQL
Server - something like Oracle, DBII, Progress, Sybase, Pervasive SQL, Ctree, you
should consider making ODBC connection from MS SQL Server as preferred first option,
as GP is MS SQL Server application


Web Site: http://www.albaspectrum.com

Contact Details: Andrew Karasev, Alba Spectrum http://www.albaspectrum.com
help@albaspectrum.com 1-866-528-0577, 1-630-961-5918, serving Great Plains USA and
Canada nationwide. Local service in Chicago, Houston, Dallas, San Diego. Please
visit our information portal Pegas Planet: http://www.pegasplanet.com . If you need
custom programming for GP, we are happy to help you with Dexterity, eConnect,
VBA/Modifier, SQL Stored Procedures, Crystal Reports. We also provide instant
support to new and existing clients via web sessions